I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the NCHAR() function today. The NCHAR() function takes an integer value, UNICODE value from 0 to 65535 and returns a single UNICODE character string. The following example returns the character ‘0’ given the UNICODE value of 48. [crayon-66446056b57d2568451057/] [crayon-66446056b57d6004779477/] One thing to always worry about when using TSQL functions is how will it react with a UNKNOWN or NULL values? [crayon-66446056b57d7742567126/] [crayon-66446056b57d8147352591/] Another thing to test is how the … Continue reading String Functions – NCHAR()